package course.dao;

import course.pojo.entity.College;
import course.pojo.vo.Page;

import java.sql.Connection;
import java.util.List;

/**
 * @author HLF
 * @date 2022/6/30 20:15
 */
public interface CollegeDao {
    College getById(Integer cid, Connection connection);

    /**
     * @return 返回自增主键
     */
    int addCollege(College college, Connection connection);

    int updateById(College college, Connection connection);

    int deleteById(Integer cid, Connection connection);

    List<College> getList(Connection connection);

    /**/

    int deleteSelect(List<Integer> ids,Connection connection);

    long count(Connection connection);

    Page<College> page(Integer pageNo,Connection connection);

    Page<College> query(String cname,Integer pageNo,Connection connection);

    College getByCname(String cname,Connection connection);

    List<College> selectBathByIds(List<Integer> ids, Connection connection);
}
